|
Managing and Executing Stored Procedures for Performance
Examine how stored procedures work and why they don't always yield better performance. Explore the reasons for this anomaly and hear about a number of practical (and safe) cures.
Building Scalable, Data-Driven Web Apps with ASP.NET and MSDE
MSDE 2000 may be free, but that doesn't mean it can't scale. Learn how to build a scalable database-driven web application using ASP.NET and MSDE 2000.
Advanced T-SQL Querying Techniques
Walk through some tough T-SQL problems like separating elements, custom aggregations (product, string concatenation), pivoting and calculating row numbers and ranks, then get an introduction to techniques that solve these problems in SQL Server 2000 and SQL Server 2005.
Building Reporting Services Applications
See how you can generate report definitions using the XML-based Report Definition Language (RDL), as well as leverage the report server SOAP and URL programmatic interfaces.
Managing a Reporting Services Implementation
Get more information on the key tasks for handling Reporting Services management.
Advanced Report Authoring with Reporting Services
Get advanced techniques for building reports with SQL Server 2000 Reporting Services and the Report Designer. Topics include: how to use the built-in expression language; data driven and hierarchical parameters; supporting multiple data sources; and making reports interactive.
Bringing the Best of Reporting Services and Analysis Services Together
See how to use Reporting Services and Analysis Services together as part of a business intelligence solution. Topics covered include: how to author MDX so that it can be used in Reporting Services reports; how to build parameterized reports for use with Analysis Services; using the drill-through features of both Analysis Services and Reporting Services; and how to use Analysis Services actions to render a report.
Reporting on Data in Exchange Using Reporting Services
Integrate Exchange and Reporting Services to collect KPI and similar data.
SQL Server Data Access Dont's
Come face-to-face with ten different data access methods that you probably have used, or still do. Learn why these methods are not recommended--from performance reasons to security reasons--and what you should be doing in your code instead.
Extending SQL Server Functionality with User-Defined Functions
Learn how to solve specific programming needs by using UDFs, which would be almost impossible using other features. In particular, the possibility of redefining system stored procedures as UDFs opens lots of exciting possibilities.
Extreme SQLXML
Learn how to leverage the advanced features of SQLXML to solve some common .NET programming and design tasks. Examples include using the SQLXML to decouple the database from the application code, generating updategrams from CLR objects, and using OpenXml to store CLR objects in SQL Server.
Preventing SQL Injection Attacks
Learn what a SQL injection attack is and why you should be concerned about one. Through demonstrations, witness different types of SQL injection attacks, how to find them, and how to block them.
Implementing Role-Based Security with ASP.NET and SQL Server
Security in Web applications is paramount, and lately quite the hot topic. Learn how to implement a complete role-based security model for a Web application.
Securing SQL Server 2000
Learn how to secure your SQL Server 2000 installation. Includes key security tasks, best practices, and discussion of the current database security threats.
Database Administration for Developers
Find out the questions you should be asking of your DBAs, and the steps you need to take to make sure your applications are covered from the server-side of things.
Patterns & Practices for Enhancing Data Integrity
Get a refresher on data integrity fundamentals, plus an overview of best practices for enforcing data integrity.
SQL Server and Distributed Transactions
Get information on the architecture and internals of distributed transaction support in SQL Server 2000.
Business Intelligence for the Relational Expert
This session covers some of the fundamental technologies you will find in any big BI and data warehouse implementation, DTS and Analysis Services, and shows how they relate to the relational databases you already know about.
Using Analysis Services with Office System 2003
Get an overview of using the OLAP components of Microsoft Office 2003 to provide business intelligence. Learn about the Excel Add-In for SQL Server Analysis Services, the Business Scorecard Accelerator, and Office Web Components.
Data Mining in SQL Server 2000 and SQL Server 2005
See how you can turn your applications into intelligent, automatically updating applications by embedding data mining using both SQL Server 2000 and SQL Server 2005.
Real-World Business Intelligence Solutions for Vertical Industries
See what BI can do for vertical industries, and get information on some real-world examples.
Using 64-bit SQL Server 2000 for Data Warehousing
Get info on using 64-bit Analysis Services, including migration tips, performance testing results, and lessons learned.
DTS and .NET in SQL Server 2000
Many DTS 2000 users have expressed an interesting in programming DTS with .NET languages. Using C#, this session covers a number of scenarios. Learn programmatic control of DTS packages from .NET, and how to develop a custom task.
A Whistle Stop Tour of SQL Server 2005
Take a tour of SQL Server 2005.
T-SQL Enhancements
See how efficient you can become with the new T-SQL enhancements. Learn how to crosstab in seconds with the PIVOT statement, perform recursive queries much easier with Common Table Expressions, manipulate XML data easier with the XML datatype and aggregate with ease using the new TOP functions.
Handling Hierarchies in T-SQL
SQL Server 2005 introduces Recursive Queries using a new construct called Common Table Expressions allowing you to manipulate hierarchical structures. Learn about solutions to Hierarchies in SQL Server 2000, and focus on the new Yukon recursive queries.
.NET Framework Programming
Learn about writing stored procedures and triggers using .NET languages (C#, VB .NET). Get architectural guidance regarding how much logic to put in the database and when to use managed code in the database versus TSQL. Learn how to write User Defined Types and User Defined Aggregates, and when to use UDTs. Also learn about the new ADO.NET in-proc provider in SQL Server 2005.
The XML Data Type
Take a look at the new XML data type and the implementation of XML in tables, parameters, and variables, and see how it differs from conventional CLOB (TEXT field) storage of an XML document.
Inside XQuery
XML brings with it some powerful query languages for dealing with the hierarchical format that it typical of an XML document. The newest and richest query language is known as XQuery. Get an overview of XQuery and explore XQuery functions and XQuery DML inside SQL Server 2005.
SQL Server 2005 as a Platform for Web Services
Get more information on the enhancements in SQL Server 2005 ti make it a great platofr for Web Services.
Security Enhancements
Get more information on the security advances that have been made in SQL Server 2005.
Introduction to the Unified Dimensional Model in Analysis Services 2005
Get more information on the UDM in SQL Server 2005
DTS Overview
Take a look at the changes and additions to DTS in SQL Server 2005.
Applying DTS
Learn advanced techniques for working with DTS in SQL Server 2005.
SQL Server 2005: What's New in Replication
Get an overview of new Replication features for SQL Server 2005.
Data Mining in SQL Server 2000 and SQL Server 2005
See how you can turn your applications into intelligent, automatically updating applications by embedding data mining using both SQL Server 2000 and SQL Server 2005.
Next-Generation SQL-DMO
SQL Server Management Objects (SMO) is a new .NET object model for managing various aspects of SQL Server 2005 as well as prior releases. This session provides detail about SMO's architecture improvements over SQL-DMO and gives you an overview of its main features.
Using Service Broker to Build Asynchronous Applications
The new Service Broker allows developers to build reliable, scalable, asynchronous, queued database applications. Learn about the major features of the Service Broker including: queues as database objects; data integrity for queued messages; activation of processing logic triggered by message arrival; and reliable, transactional delivery of messages between SQL Server instances.
MDAC Servicing: Best Practices for Handling MDAC Updates
Lots of changes are "coming soon" to the world of MDAC installations. The first area is completely new installation technology. Learn about some secrets for deploying and troubleshooting both versions of MDAC hotfixes going forward. Learn about the overall plan and see how this is going to affect the next Windows service packs. Explore the new MDAC shipping with SQL Server 2005 and what changes you can expect in this space.
Connected vs. Disconnected Data Access with ADO.NET
ADO.NET has first-class support for both connected and disconnected operation. Each of these modes applies to different application scenarios and performance/scalability requirements. Learn why connected or disconnected access is best for a particular application and why a bad choice may hurt performance or add unnecessary complexity to a system.
Understanding and Optimizing ADO.NET 1.1 Performance
Get an in-depth analysis of the factors that affect ADO.NET performance, including how the ADO.NET architecture and database behavior impacts performance.
XML Today and Tomorrow
Every developer needs to know how to work with XML in their applications today and with new developments occurring within in the industry this need will further increase. This talk focuses on real-world XML scenarios that developers are running into today using the XML programming support that exists in the .NET framework and it also highlights the XML programming improvement in the next release.
What's New in ADO.NET 2.0
Explore the new extensions and enhancements in ADO.NET in the Visual Studio 2005 release, including better performance, a provider independent programming model and great integration with SQL Server 2005.
| |
Top of Page
